Airbnb Data Profiling

Dataset statistics

Number of variables	17
Number of observations	42931
Missing cells	63506
Missing cells (%)	8.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.6 MiB
Average record size in memory	136.0 B

Variable types

Numeric	10
Text	4
Categorical	2
DateTime	1

Alerts

`host_id` is highly overall correlated with `id`	High correlation
`id` is highly overall correlated with `host_id`	High correlation
`latitude` is highly overall correlated with `neighbourhood_group`	High correlation
`longitude` is highly overall correlated with `neighbourhood_group`	High correlation
`minimum_nights` is highly overall correlated with `number_of_reviews_ltm` and 1 other fields	High correlation
`neighbourhood_group` is highly overall correlated with `latitude` and 1 other fields	High correlation
`number_of_reviews` is highly overall correlated with `number_of_reviews_ltm` and 1 other fields	High correlation
`number_of_reviews_ltm` is highly overall correlated with `minimum_nights` and 2 other fields	High correlation
`reviews_per_month` is highly overall correlated with `minimum_nights` and 2 other fields	High correlation
`last_review` has 10304 (24.0%) missing values	Missing
`reviews_per_month` has 10304 (24.0%) missing values	Missing
`detailed_location` has 42881 (99.9%) missing values	Missing
`price` is highly skewed (γ1 = 81.45449106)	Skewed
`id` has unique values	Unique
`number_of_reviews` has 10304 (24.0%) zeros	Zeros
`number_of_reviews_ltm` has 21470 (50.0%) zeros	Zeros

Reproduction

Analysis started	2024-05-07 06:13:57.996604
Analysis finished	2024-05-07 06:14:32.812553
Duration	34.82 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	42931
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.2227724 × 10¹⁷

Minimum	2595
Maximum	8.4046605 × 10¹⁷
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.5 KiB

Quantile statistics

Minimum	2595
5-th percentile	3039221
Q1	19404736
median	43374815
Q3	6.305016 × 10¹⁷
95-th percentile	8.076607 × 10¹⁷
Maximum	8.4046605 × 10¹⁷
Range	8.4046605 × 10¹⁷
Interquartile range (IQR)	6.305016 × 10¹⁷

Descriptive statistics

Standard deviation	3.344213 × 10¹⁷
Coefficient of variation (CV)	1.5045233
Kurtosis	-1.1494006
Mean	2.2227724 × 10¹⁷
Median Absolute Deviation (MAD)	29842097
Skewness	0.87882551
Sum	5.6176987 × 10¹⁸
Variance	1.1183761 × 10³⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2595	1	< 0.1%
53574639	1	< 0.1%
53605871	1	< 0.1%
53605960	1	< 0.1%
53606101	1	< 0.1%
53606289	1	< 0.1%
53575004	1	< 0.1%
53606306	1	< 0.1%
53606376	1	< 0.1%
53606452	1	< 0.1%
Other values (42921)	42921	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2595	1	< 0.1%
5121	1	< 0.1%
5136	1	< 0.1%
5178	1	< 0.1%
5203	1	< 0.1%
5586	1	< 0.1%
5803	1	< 0.1%
6848	1	< 0.1%
6872	1	< 0.1%
6990	1	< 0.1%

Value	Count	Frequency (%)
8.404660471 × 10¹⁷	1	< 0.1%
8.402288788 × 10¹⁷	1	< 0.1%
8.401503224 × 10¹⁷	1	< 0.1%
8.400804342 × 10¹⁷	1	< 0.1%
8.40049771 × 10¹⁷	1	< 0.1%
8.400478127 × 10¹⁷	1	< 0.1%
8.400315504 × 10¹⁷	1	< 0.1%
8.399770476 × 10¹⁷	1	< 0.1%
8.39959564 × 10¹⁷	1	< 0.1%
8.399557651 × 10¹⁷	1	< 0.1%

name
Text

Distinct	41408
Distinct (%)	96.5%
Missing	12
Missing (%)	< 0.1%
Memory size	335.5 KiB

Length

Max length	248
Median length	114
Mean length	37.643794
Min length	1

Characters and Unicode

Total characters	1615634
Distinct characters	838
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	40591 ?
Unique (%)	94.6%

Sample

1st row	Skylit Midtown Castle
2nd row	BlissArtsSpace!
3rd row	Cozy Clean Guest Room - Family Apt
4th row	Large Furnished Room Near B'way
5th row	Large Sunny Brooklyn Duplex, Patio + Garden

Value	Count	Frequency (%)
in	13926	5.2%
room	7890	2.9%
	7235	2.7%
bedroom	7142	2.7%
private	6183	2.3%
apartment	5696	2.1%
cozy	4040	1.5%
studio	3712	1.4%
apt	3629	1.3%
the	3612	1.3%
Other values (12721)	206018	76.6%

Most occurring characters

Value	Count	Frequency (%)
	227633	14.1%
e	118241	7.3%
o	112670	7.0%
t	94796	5.9%
a	91102	5.6%
r	88976	5.5%
n	84848	5.3%
i	84620	5.2%
l	46838	2.9%
m	43858	2.7%
Other values (828)	622052	38.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1615634	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	227633	14.1%
e	118241	7.3%
o	112670	7.0%
t	94796	5.9%
a	91102	5.6%
r	88976	5.5%
n	84848	5.3%
i	84620	5.2%
l	46838	2.9%
m	43858	2.7%
Other values (828)	622052	38.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1615634	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	227633	14.1%
e	118241	7.3%
o	112670	7.0%
t	94796	5.9%
a	91102	5.6%
r	88976	5.5%
n	84848	5.3%
i	84620	5.2%
l	46838	2.9%
m	43858	2.7%
Other values (828)	622052	38.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1615634	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	227633	14.1%
e	118241	7.3%
o	112670	7.0%
t	94796	5.9%
a	91102	5.6%
r	88976	5.5%
n	84848	5.3%
i	84620	5.2%
l	46838	2.9%
m	43858	2.7%
Other values (828)	622052	38.5%

host_id
Real number (ℝ)

HIGH CORRELATION

Distinct	27455
Distinct (%)	64.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5160121 × 10⁸

Minimum	1678
Maximum	5.0387289 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.5 KiB

Quantile statistics

Minimum	1678
5-th percentile	1398639
Q1	16085328
median	74338125
Q3	2.6806924 × 10⁸
95-th percentile	4.7498775 × 10⁸
Maximum	5.0387289 × 10⁸
Range	5.0387121 × 10⁸
Interquartile range (IQR)	2.5198391 × 10⁸

Descriptive statistics

Standard deviation	1.6213011 × 10⁸
Coefficient of variation (CV)	1.0694513
Kurtosis	-0.70164463
Mean	1.5160121 × 10⁸
Median Absolute Deviation (MAD)	70621479
Skewness	0.86158061
Sum	6.5083915 × 10¹²
Variance	2.6286172 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
107434423	526	1.2%
3223938	394	0.9%
496944100	356	0.8%
305240193	222	0.5%
19303369	207	0.5%
200239515	192	0.4%
204704622	178	0.4%
162280872	159	0.4%
51501835	131	0.3%
137358866	124	0.3%
Other values (27445)	40442	94.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1678	1	< 0.1%
2234	1	< 0.1%
2438	1	< 0.1%
2571	1	< 0.1%
2782	1	< 0.1%
2787	7	< 0.1%
2845	3	< 0.1%
2868	1	< 0.1%
3647	1	< 0.1%
3757	1	< 0.1%

Value	Count	Frequency (%)
503872891	1	< 0.1%
503757175	1	< 0.1%
503726515	1	< 0.1%
503718879	1	< 0.1%
503593397	1	< 0.1%
503579221	1	< 0.1%
503563559	1	< 0.1%
503556906	1	< 0.1%
503542653	1	< 0.1%
503540971	1	< 0.1%

host_name
Text

Distinct	9831
Distinct (%)	22.9%
Missing	5
Missing (%)	< 0.1%
Memory size	335.5 KiB

Length

Max length	35
Median length	33
Mean length	6.5092951
Min length	1

Characters and Unicode

Total characters	279418
Distinct characters	151
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5667 ?
Unique (%)	13.2%

Sample

1st row	Jennifer
2nd row	Garon
3rd row	MaryEllen
4th row	Shunichi
5th row	Rebecca

Value	Count	Frequency (%)
	614	1.3%
roompicks	608	1.2%
blueground	526	1.1%
and	497	1.0%
eugene	400	0.8%
michael	346	0.7%
david	326	0.7%
alex	256	0.5%
kristina	256	0.5%
by	233	0.5%
Other values (9170)	44983	91.7%

Most occurring characters

Value	Count	Frequency (%)
a	32451	11.6%
e	26336	9.4%
i	22166	7.9%
n	22036	7.9%
r	16248	5.8%
o	14270	5.1%
l	13690	4.9%
s	9277	3.3%
t	9041	3.2%
h	8220	2.9%
Other values (141)	105683	37.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	279418	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	32451	11.6%
e	26336	9.4%
i	22166	7.9%
n	22036	7.9%
r	16248	5.8%
o	14270	5.1%
l	13690	4.9%
s	9277	3.3%
t	9041	3.2%
h	8220	2.9%
Other values (141)	105683	37.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	279418	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	32451	11.6%
e	26336	9.4%
i	22166	7.9%
n	22036	7.9%
r	16248	5.8%
o	14270	5.1%
l	13690	4.9%
s	9277	3.3%
t	9041	3.2%
h	8220	2.9%
Other values (141)	105683	37.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	279418	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	32451	11.6%
e	26336	9.4%
i	22166	7.9%
n	22036	7.9%
r	16248	5.8%
o	14270	5.1%
l	13690	4.9%
s	9277	3.3%
t	9041	3.2%
h	8220	2.9%
Other values (141)	105683	37.8%

neighbourhood_group
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	335.5 KiB

Manhattan	17658
Brooklyn	16237
Queens	6916
Bronx	1691
Staten Island	429

Length

Max length	13
Median length	9
Mean length	8.0209173
Min length	5

Characters and Unicode

Total characters	344346
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Manhattan
2nd row	Brooklyn
3rd row	Manhattan
4th row	Manhattan
5th row	Brooklyn

Common Values

Value	Count	Frequency (%)
Manhattan	17658	41.1%
Brooklyn	16237	37.8%
Queens	6916	16.1%
Bronx	1691	3.9%
Staten Island	429	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
manhattan	17658	40.7%
brooklyn	16237	37.4%
queens	6916	16.0%
bronx	1691	3.9%
staten	429	1.0%
island	429	1.0%

Most occurring characters

Value	Count	Frequency (%)
n	61018	17.7%
a	53832	15.6%
t	36174	10.5%
o	34165	9.9%
B	17928	5.2%
r	17928	5.2%
M	17658	5.1%
h	17658	5.1%
l	16666	4.8%
y	16237	4.7%
Other values (10)	55082	16.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	344346	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	61018	17.7%
a	53832	15.6%
t	36174	10.5%
o	34165	9.9%
B	17928	5.2%
r	17928	5.2%
M	17658	5.1%
h	17658	5.1%
l	16666	4.8%
y	16237	4.7%
Other values (10)	55082	16.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	344346	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	61018	17.7%
a	53832	15.6%
t	36174	10.5%
o	34165	9.9%
B	17928	5.2%
r	17928	5.2%
M	17658	5.1%
h	17658	5.1%
l	16666	4.8%
y	16237	4.7%
Other values (10)	55082	16.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	344346	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	61018	17.7%
a	53832	15.6%
t	36174	10.5%
o	34165	9.9%
B	17928	5.2%
r	17928	5.2%
M	17658	5.1%
h	17658	5.1%
l	16666	4.8%
y	16237	4.7%
Other values (10)	55082	16.0%

neighbourhood
Text

Distinct	223
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	335.5 KiB

Length

Max length	25
Median length	17
Mean length	11.700147
Min length	4

Characters and Unicode

Total characters	502299
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	Midtown
2nd row	Bedford-Stuyvesant
3rd row	Upper West Side
4th row	Midtown
5th row	Sunset Park

Value	Count	Frequency (%)
east	5412	7.9%
side	3673	5.3%
bedford-stuyvesant	3086	4.5%
upper	2973	4.3%
harlem	2935	4.3%
heights	2914	4.2%
williamsburg	2597	3.8%
midtown	2182	3.2%
village	2116	3.1%
west	2110	3.1%
Other values (236)	38922	56.5%

Most occurring characters

Value	Count	Frequency (%)
e	45003	9.0%
i	35535	7.1%
s	34196	6.8%
t	34054	6.8%
a	33155	6.6%
r	28945	5.8%
l	28068	5.6%
	25989	5.2%
n	23566	4.7%
o	22306	4.4%
Other values (44)	191482	38.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	502299	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	45003	9.0%
i	35535	7.1%
s	34196	6.8%
t	34054	6.8%
a	33155	6.6%
r	28945	5.8%
l	28068	5.6%
	25989	5.2%
n	23566	4.7%
o	22306	4.4%
Other values (44)	191482	38.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	502299	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	45003	9.0%
i	35535	7.1%
s	34196	6.8%
t	34054	6.8%
a	33155	6.6%
r	28945	5.8%
l	28068	5.6%
	25989	5.2%
n	23566	4.7%
o	22306	4.4%
Other values (44)	191482	38.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	502299	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	45003	9.0%
i	35535	7.1%
s	34196	6.8%
t	34054	6.8%
a	33155	6.6%
r	28945	5.8%
l	28068	5.6%
	25989	5.2%
n	23566	4.7%
o	22306	4.4%
Other values (44)	191482	38.1%

latitude
Real number (ℝ)

HIGH CORRELATION

Distinct	22673
Distinct (%)	52.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.728273

Minimum	40.500314
Maximum	40.91138
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.5 KiB

Quantile statistics

Minimum	40.500314
5-th percentile	40.640268
Q1	40.687485
median	40.72404
Q3	40.762293
95-th percentile	40.82956
Maximum	40.91138
Range	0.41106557
Interquartile range (IQR)	0.074808455

Descriptive statistics

Standard deviation	0.057640457
Coefficient of variation (CV)	0.0014152443
Kurtosis	0.13647495
Mean	40.728273
Median Absolute Deviation (MAD)	0.03747
Skewness	0.2179238
Sum	1748505.5
Variance	0.0033224223
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.76153	52	0.1%
40.76411	32	0.1%
40.760452	24	0.1%
40.761532	22	0.1%
40.7607614	22	0.1%
40.73756	19	< 0.1%
40.75436	19	< 0.1%
40.71899	18	< 0.1%
40.74926	17	< 0.1%
40.71579	17	< 0.1%
Other values (22663)	42689	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
40.50031443	1	< 0.1%
40.50456	1	< 0.1%
40.507114	1	< 0.1%
40.50848895	1	< 0.1%
40.50863	1	< 0.1%
40.52034	1	< 0.1%
40.52224	1	< 0.1%
40.52339	1	< 0.1%
40.52498	1	< 0.1%
40.53125	1	< 0.1%

Value	Count	Frequency (%)
40.91138	1	< 0.1%
40.91114684	1	< 0.1%
40.91062	1	< 0.1%
40.90884	1	< 0.1%
40.90530196	1	< 0.1%
40.90505	1	< 0.1%
40.90424	1	< 0.1%
40.90421	1	< 0.1%
40.90403	1	< 0.1%
40.90376	1	< 0.1%

longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	20130
Distinct (%)	46.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-73.943665

Minimum	-74.251907
Maximum	-73.71087
Zeros	0
Zeros (%)	0.0%
Negative	42931
Negative (%)	100.0%
Memory size	335.5 KiB

Quantile statistics

Minimum	-74.251907
5-th percentile	-74.003735
Q1	-73.98175
median	-73.95262
Q3	-73.924035
95-th percentile	-73.820533
Maximum	-73.71087
Range	0.541037
Interquartile range (IQR)	0.057715

Descriptive statistics

Standard deviation	0.056626547
Coefficient of variation (CV)	-0.0007658066
Kurtosis	3.0410896
Mean	-73.943665
Median Absolute Deviation (MAD)	0.02895
Skewness	1.1475906
Sum	-3174475.5
Variance	0.0032065658
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.99878	52	0.1%
-73.99371	30	0.1%
-73.99391	24	0.1%
-73.76606	24	0.1%
-73.97643	24	0.1%
-73.9861055	22	0.1%
-74.00587	22	0.1%
-73.998779	22	0.1%
-73.9535	20	< 0.1%
-73.98698	18	< 0.1%
Other values (20120)	42673	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-74.251907	1	< 0.1%
-74.24984	1	< 0.1%
-74.24308594	1	< 0.1%
-74.24135	1	< 0.1%
-74.23913565	1	< 0.1%
-74.21514	1	< 0.1%
-74.21126	1	< 0.1%
-74.21088	1	< 0.1%
-74.21065716	1	< 0.1%
-74.20739	1	< 0.1%

Value	Count	Frequency (%)
-73.71087	1	< 0.1%
-73.71299	1	< 0.1%
-73.71439	1	< 0.1%
-73.7174099	1	< 0.1%
-73.71974787	1	< 0.1%
-73.71991	1	< 0.1%
-73.72054	1	< 0.1%
-73.7216024	1	< 0.1%
-73.72408	1	< 0.1%
-73.72434	1	< 0.1%

room_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	335.5 KiB

Entire home/apt	24279
Private room	17879
Shared room	576
Hotel room	197

Length

Max length	15
Median length	15
Mean length	13.674012
Min length	10

Characters and Unicode

Total characters	587039
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Entire home/apt
2nd row	Private room
3rd row	Private room
4th row	Private room
5th row	Entire home/apt

Common Values

Value	Count	Frequency (%)
Entire home/apt	24279	56.6%
Private room	17879	41.6%
Shared room	576	1.3%
Hotel room	197	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	24279	28.3%
home/apt	24279	28.3%
room	18652	21.7%
private	17879	20.8%
shared	576	0.7%
hotel	197	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	67210	11.4%
t	66634	11.4%
o	61780	10.5%
r	61386	10.5%
m	42931	7.3%
	42931	7.3%
a	42734	7.3%
i	42158	7.2%
h	24855	4.2%
p	24279	4.1%
Other values (9)	110141	18.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	587039	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	67210	11.4%
t	66634	11.4%
o	61780	10.5%
r	61386	10.5%
m	42931	7.3%
	42931	7.3%
a	42734	7.3%
i	42158	7.2%
h	24855	4.2%
p	24279	4.1%
Other values (9)	110141	18.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	587039	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	67210	11.4%
t	66634	11.4%
o	61780	10.5%
r	61386	10.5%
m	42931	7.3%
	42931	7.3%
a	42734	7.3%
i	42158	7.2%
h	24855	4.2%
p	24279	4.1%
Other values (9)	110141	18.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	587039	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	67210	11.4%
t	66634	11.4%
o	61780	10.5%
r	61386	10.5%
m	42931	7.3%
	42931	7.3%
a	42734	7.3%
i	42158	7.2%
h	24855	4.2%
p	24279	4.1%
Other values (9)	110141	18.8%

price
Real number (ℝ)

SKEWED

Distinct	1089
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	200.30717

Minimum	0
Maximum	99000
Zeros	27
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	335.5 KiB

Quantile statistics

Minimum	0
5-th percentile	40
Q1	75
median	125
Q3	200
95-th percentile	499
Maximum	99000
Range	99000
Interquartile range (IQR)	125

Descriptive statistics

Standard deviation	895.08291
Coefficient of variation (CV)	4.4685516
Kurtosis	7897.8051
Mean	200.30717
Median Absolute Deviation (MAD)	59
Skewness	81.454491
Sum	8599387
Variance	801173.42
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
150	1254	2.9%
100	1144	2.7%
200	886	2.1%
120	784	1.8%
60	765	1.8%
75	746	1.7%
50	736	1.7%
80	728	1.7%
70	697	1.6%
90	691	1.6%
Other values (1079)	34500	80.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	27	0.1%
10	7	< 0.1%
15	2	< 0.1%
16	3	< 0.1%
18	2	< 0.1%
19	5	< 0.1%
20	18	< 0.1%
21	3	< 0.1%
22	15	< 0.1%
23	18	< 0.1%

Value	Count	Frequency (%)
99000	1	< 0.1%
85170	1	< 0.1%
85100	1	< 0.1%
65115	1	< 0.1%
20500	1	< 0.1%
19750	1	< 0.1%
15000	1	< 0.1%
10000	9	< 0.1%
9999	4	< 0.1%
9994	1	< 0.1%

minimum_nights
Real number (ℝ)

HIGH CORRELATION

Distinct	128
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.111178

Minimum	1
Maximum	1250
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	7
Q3	30
95-th percentile	30
Maximum	1250
Range	1249
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	27.462513
Coefficient of variation (CV)	1.5163294
Kurtosis	334.65305
Mean	18.111178
Median Absolute Deviation (MAD)	6
Skewness	12.426192
Sum	777531
Variance	754.18962
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	18235	42.5%
1	7946	18.5%
2	5524	12.9%
3	3814	8.9%
5	1499	3.5%
4	1422	3.3%
7	922	2.1%
31	786	1.8%
90	472	1.1%
6	370	0.9%
Other values (118)	1941	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7946	18.5%
2	5524	12.9%
3	3814	8.9%
4	1422	3.3%
5	1499	3.5%
6	370	0.9%
7	922	2.1%
8	53	0.1%
9	27	0.1%
10	218	0.5%

Value	Count	Frequency (%)
1250	1	< 0.1%
1124	1	< 0.1%
1000	2	< 0.1%
999	1	< 0.1%
500	6	< 0.1%
480	1	< 0.1%
400	3	< 0.1%
370	1	< 0.1%
366	1	< 0.1%
365	51	0.1%

number_of_reviews
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	476
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25.856001

Minimum	0
Maximum	1842
Zeros	10304
Zeros (%)	24.0%
Negative	0
Negative (%)	0.0%
Memory size	335.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	5
Q3	24
95-th percentile	129
Maximum	1842
Range	1842
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	56.616344
Coefficient of variation (CV)	2.189679
Kurtosis	73.000382
Mean	25.856001
Median Absolute Deviation (MAD)	5
Skewness	5.7317373
Sum	1110024
Variance	3205.4104
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10304	24.0%
1	4410	10.3%
2	2894	6.7%
3	2052	4.8%
4	1577	3.7%
5	1289	3.0%
6	1110	2.6%
7	1002	2.3%
8	813	1.9%
9	751	1.7%
Other values (466)	16729	39.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10304	24.0%
1	4410	10.3%
2	2894	6.7%
3	2052	4.8%
4	1577	3.7%
5	1289	3.0%
6	1110	2.6%
7	1002	2.3%
8	813	1.9%
9	751	1.7%

Value	Count	Frequency (%)
1842	1	< 0.1%
1642	1	< 0.1%
1097	1	< 0.1%
1010	1	< 0.1%
985	1	< 0.1%
948	1	< 0.1%
917	1	< 0.1%
798	1	< 0.1%
789	1	< 0.1%
766	1	< 0.1%

last_review
Date

MISSING

Distinct	2795
Distinct (%)	8.6%
Missing	10304
Missing (%)	24.0%
Memory size	335.5 KiB

Minimum	2011-05-12 00:00:00
Maximum	2023-03-06 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

reviews_per_month
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	881
Distinct (%)	2.7%
Missing	10304
Missing (%)	24.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1689883

Minimum	0.01
Maximum	86.61
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.5 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.02
Q1	0.14
median	0.52
Q3	1.67
95-th percentile	4.09
Maximum	86.61
Range	86.6
Interquartile range (IQR)	1.53

Descriptive statistics

Standard deviation	1.7896749
Coefficient of variation (CV)	1.5309605
Kurtosis	302.80799
Mean	1.1689883
Median Absolute Deviation (MAD)	0.47
Skewness	10.30231
Sum	38140.58
Variance	3.2029362
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02	1063	2.5%
0.01	965	2.2%
0.03	826	1.9%
0.05	779	1.8%
0.04	722	1.7%
0.07	595	1.4%
0.06	514	1.2%
0.1	493	1.1%
1	476	1.1%
0.08	466	1.1%
Other values (871)	25728	59.9%
(Missing)	10304	24.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	965	2.2%
0.02	1063	2.5%
0.03	826	1.9%
0.04	722	1.7%
0.05	779	1.8%
0.06	514	1.2%
0.07	595	1.4%
0.08	466	1.1%
0.09	459	1.1%
0.1	493	1.1%

Value	Count	Frequency (%)
86.61	1	< 0.1%
61.26	1	< 0.1%
55.46	1	< 0.1%
51.71	1	< 0.1%
45.53	1	< 0.1%
43.75	1	< 0.1%
40.78	1	< 0.1%
36.94	1	< 0.1%
35.96	1	< 0.1%
33.81	1	< 0.1%

calculated_host_listings_count
Real number (ℝ)

Distinct	65
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.054809

Minimum	1
Maximum	526
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	4
95-th percentile	159
Maximum	526
Range	525
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	80.867958
Coefficient of variation (CV)	3.3618209
Kurtosis	22.085603
Mean	24.054809
Median Absolute Deviation (MAD)	0
Skewness	4.6167703
Sum	1032697
Variance	6539.6266
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	22528	52.5%
2	5666	13.2%
3	2814	6.6%
4	1740	4.1%
5	1020	2.4%
6	768	1.8%
8	560	1.3%
7	546	1.3%
526	526	1.2%
394	394	0.9%
Other values (55)	6369	14.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	22528	52.5%
2	5666	13.2%
3	2814	6.6%
4	1740	4.1%
5	1020	2.4%
6	768	1.8%
7	546	1.3%
8	560	1.3%
9	315	0.7%
10	320	0.7%

Value	Count	Frequency (%)
526	526	1.2%
394	394	0.9%
356	356	0.8%
222	222	0.5%
207	207	0.5%
192	192	0.4%
178	178	0.4%
159	159	0.4%
131	131	0.3%
124	248	0.6%

number_of_reviews_ltm
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	168
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.7365074

Minimum	0
Maximum	1093
Zeros	21470
Zeros (%)	50.0%
Negative	0
Negative (%)	0.0%
Memory size	335.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	7
95-th percentile	40
Maximum	1093
Range	1093
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	18.290256
Coefficient of variation (CV)	2.3641489
Kurtosis	584.39757
Mean	7.7365074
Median Absolute Deviation (MAD)	0
Skewness	14.547605
Sum	332136
Variance	334.53346
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	21470	50.0%
1	3377	7.9%
2	2238	5.2%
3	1711	4.0%
4	1226	2.9%
5	956	2.2%
6	755	1.8%
7	628	1.5%
8	532	1.2%
10	479	1.1%
Other values (158)	9559	22.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	21470	50.0%
1	3377	7.9%
2	2238	5.2%
3	1711	4.0%
4	1226	2.9%
5	956	2.2%
6	755	1.8%
7	628	1.5%
8	532	1.2%
9	457	1.1%

Value	Count	Frequency (%)
1093	1	< 0.1%
889	1	< 0.1%
770	1	< 0.1%
668	1	< 0.1%
530	1	< 0.1%
458	1	< 0.1%
442	1	< 0.1%
379	1	< 0.1%
368	1	< 0.1%
354	1	< 0.1%

detailed_location
Text

MISSING

Distinct	50
Distinct (%)	100.0%
Missing	42881
Missing (%)	99.9%
Memory size	335.5 KiB

Length

Max length	87
Median length	76
Mean length	65.38
Min length	56

Characters and Unicode

Total characters	3269
Distinct characters	57
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	50 ?
Unique (%)	100.0%

Sample

1st row	104 West 40th Street, New York, NY 10018, United States of America
2nd row	294 Gates Avenue, New York, NY 11216, United States of America
3rd row	301 West 109th Street, New York, NY 10025, United States of America
4th row	Hilton Garden Inn, 237 West 54th Street, New York, NY 10019, United States of America
5th row	Al-Noor School, 675 4th Avenue, New York, NY 11232, United States of America

Value	Count	Frequency (%)
new	50	8.7%
york	50	8.7%
ny	50	8.7%
united	50	8.7%
states	50	8.7%
of	50	8.7%
america	50	8.7%
street	31	5.4%
avenue	16	2.8%
west	13	2.2%
Other values (142)	168	29.1%

Most occurring characters

Value	Count	Frequency (%)
	528	16.2%
e	332	10.2%
t	269	8.2%
,	155	4.7%
r	149	4.6%
1	139	4.3%
o	125	3.8%
a	121	3.7%
i	107	3.3%
N	102	3.1%
Other values (47)	1242	38.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3269	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	528	16.2%
e	332	10.2%
t	269	8.2%
,	155	4.7%
r	149	4.6%
1	139	4.3%
o	125	3.8%
a	121	3.7%
i	107	3.3%
N	102	3.1%
Other values (47)	1242	38.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3269	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	528	16.2%
e	332	10.2%
t	269	8.2%
,	155	4.7%
r	149	4.6%
1	139	4.3%
o	125	3.8%
a	121	3.7%
i	107	3.3%
N	102	3.1%
Other values (47)	1242	38.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3269	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	528	16.2%
e	332	10.2%
t	269	8.2%
,	155	4.7%
r	149	4.6%
1	139	4.3%
o	125	3.8%
a	121	3.7%
i	107	3.3%
N	102	3.1%
Other values (47)	1242	38.0%

Auto

Heatmap
Table

	calculated_host_listings_count	host_id	id	latitude	longitude	minimum_nights	neighbourhood_group	number_of_reviews	number_of_reviews_ltm	price	reviews_per_month	room_type
calculated_host_listings_count	1.000	0.251	0.328	0.089	-0.005	-0.051	0.149	-0.117	0.063	-0.049	0.130	0.110
host_id	0.251	1.000	0.542	0.046	0.125	-0.311	0.111	-0.102	0.148	0.019	0.309	0.104
id	0.328	0.542	1.000	0.001	0.096	-0.365	0.057	-0.333	0.156	0.114	0.430	0.033
latitude	0.089	0.046	0.001	1.000	0.011	0.061	0.558	-0.075	-0.080	0.081	-0.074	0.084
longitude	-0.005	0.125	0.096	0.011	1.000	-0.149	0.680	0.102	0.151	-0.390	0.176	0.112
minimum_nights	-0.051	-0.311	-0.365	0.061	-0.149	1.000	0.008	-0.302	-0.525	-0.149	-0.622	0.018
neighbourhood_group	0.149	0.111	0.057	0.558	0.680	0.008	1.000	-0.034	-0.004	0.061	0.024	0.094
number_of_reviews	-0.117	-0.102	-0.333	-0.075	0.102	-0.302	-0.034	1.000	0.698	-0.025	0.699	0.043
number_of_reviews_ltm	0.063	0.148	0.156	-0.080	0.151	-0.525	-0.004	0.698	1.000	0.055	0.834	0.023
price	-0.049	0.019	0.114	0.081	-0.390	-0.149	0.061	-0.025	0.055	1.000	0.090	0.000
reviews_per_month	0.130	0.309	0.430	-0.074	0.176	-0.622	0.024	0.699	0.834	0.090	1.000	0.033
room_type	0.110	0.104	0.033	0.084	0.112	0.018	0.094	0.043	0.023	0.000	0.033	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	number_of_reviews_ltm	detailed_location
0	2595	Skylit Midtown Castle	2845	Jennifer	Manhattan	Midtown	40.75356	-73.98559	Entire home/apt	150	30	49	2022-06-21	0.30	3	1	104 West 40th Street, New York, NY 10018, United States of America
1	5121	BlissArtsSpace!	7356	Garon	Brooklyn	Bedford-Stuyvesant	40.68535	-73.95512	Private room	60	30	50	2019-12-02	0.30	2	0	294 Gates Avenue, New York, NY 11216, United States of America
2	5203	Cozy Clean Guest Room - Family Apt	7490	MaryEllen	Manhattan	Upper West Side	40.80380	-73.96751	Private room	75	2	118	2017-07-21	0.72	1	0	301 West 109th Street, New York, NY 10025, United States of America
3	5178	Large Furnished Room Near B'way	8967	Shunichi	Manhattan	Midtown	40.76457	-73.98317	Private room	68	2	575	2023-02-19	3.41	1	52	Hilton Garden Inn, 237 West 54th Street, New York, NY 10019, United States of America
4	5136	Large Sunny Brooklyn Duplex, Patio + Garden	7378	Rebecca	Brooklyn	Sunset Park	40.66265	-73.99454	Entire home/apt	275	60	3	2022-08-10	0.03	1	1	Al-Noor School, 675 4th Avenue, New York, NY 11232, United States of America
5	29628	Comfortable, Sunny Room	127608	Chris	Brooklyn	Clinton Hill	40.68292	-73.96381	Private room	93	3	350	2023-02-27	2.25	1	48	Fulton Street, New York, NY 11207, United States of America
6	5586	Rooftop Deck/City Views. Great Apt	8526	Susan	Manhattan	Upper East Side	40.76076	-73.96156	Entire home/apt	295	4	45	2022-10-03	0.27	1	4	1107 1st Avenue, New York, NY 10065, United States of America
7	5803	Lovely, Cozy, Room 1, BEST AREA; Legal Rental	9744	Laurie	Brooklyn	South Slope	40.66801	-73.98784	Private room	124	3	223	2023-02-13	1.32	3	17	318 11th Street, New York, NY 11215, United States of America
8	31130	Most Central Location!	117287	Lara Nicole	Manhattan	Hell's Kitchen	40.76720	-73.98464	Private room	200	1	68	2021-10-01	0.44	4	0	West 57th Street, New York, NY 10019, United States of America
9	6848	Only 2 stops to Manhattan studio	15991	Allen & Irina	Brooklyn	Williamsburg	40.70935	-73.95342	Entire home/apt	81	30	189	2023-02-04	1.13	1	5	353 South 3rd Street, New York, NY 11211, United States of America

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	last_review	reviews_per_month	calculated_host_listings_count	detailed_location
42921	839542253443554475	Charming Private BD w/shared BR & Kitchen	429095657	Aurgho	Queens	Jackson Heights	40.751823	-73.892451	Private room	80	1	NaN	NaN	3	NaN
42922	839604405796522504	Cozy clean room in Brooklyn	272771643	Analisa	Brooklyn	Bedford-Stuyvesant	40.691720	-73.945442	Private room	36	4	NaN	NaN	1	NaN
42923	839607315156742936	Spacious private BD w/ shared BR & Kitchen	429095657	Aurgho	Queens	Jackson Heights	40.753224	-73.892610	Private room	96	1	NaN	NaN	3	NaN
42924	839655582695838383	Room near jfk airport	142852663	Monika	Queens	South Ozone Park	40.673400	-73.806280	Private room	68	1	NaN	NaN	1	NaN
42925	839728752538060549	North Slope 1 Bedroom 1 Bath	452459370	Lee	Brooklyn	Park Slope	40.671510	-73.979431	Entire home/apt	100	14	NaN	NaN	1	NaN
42926	839753193689829909	bright studio in Williamsburg	28057253	Jean	Brooklyn	Williamsburg	40.718976	-73.963985	Entire home/apt	76	7	NaN	NaN	1	NaN
42927	839786573617495393	Room in the heart of LES with Gym& Rooftop BBQ	247439246	Charlene	Manhattan	East Village	40.721703	-73.981473	Private room	32	30	NaN	NaN	5	NaN
42928	839797749155954018	Fantastic 3BD apt in Brooklyn	26349246	Jose	Brooklyn	Bushwick	40.688700	-73.907650	Entire home/apt	127	3	NaN	NaN	8	NaN
42929	839814083143454171	The Coziest Home	48533809	Remmy	Staten Island	Bull's Head	40.616911	-74.164652	Entire home/apt	280	1	NaN	NaN	1	NaN
42930	839817199240589949	378-2L-Red	488616033	Mikey	Brooklyn	Williamsburg	40.713091	-73.957205	Private room	78	90	NaN	NaN	69	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample